EMT Practice Test

1. Question Content...

---

Question1: Which of the following will MOST likely be streamed live?

Question2: Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Question3: What would be an example of an acceptable form of primary identification for the Data+ exam?

Question4: Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Question5: A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Question6: Which of the following is an example of a discrete data type?

Question7: You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

Question8: Which of the following is the correct data type for text?

Question9: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question10: An analyst modified a data set that had a number of issues. Given the original and modified versions:

Which of the following data manipulation techniques did the analyst use?

Question11: An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

Question12: A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid.
Which of the following query optimization techniques would effectively prevent SQL Injection attacks?

Question13: Five dogs have the following heights in millimeters:
300,430, 170, 470, 600
Which of the following is the standard deviation for the five dogs?

Question14: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question15: A financial analyst is creating a daily billing report for a company. One night, the company's data warehouse did not update the data, which caused the data to be reported incorrectly the next day. Which of the following documentation elements should the analyst add to catch this error?

Question16: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question17: A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

Question18: An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Question19: 'Which of the following is the BEST reason to use database views instead of tables?

Question20: A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed report that is generated by the accounting department at the beginning of each week. Consequently, the collections team calls some customers who have made payments in the time since the report was last printed. Which of the following reporting enhancements could the accounting department implement to best reduce the number of calls on current accounts?

Question21: Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Question22: An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey that information?

Question23: Which of the following is an example of a at flat file?

Question24: A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

Question25: Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

Question26: Which of the following is a control measure for preventing a data breach?

Question27: Given the data below:

In which of the following file formats is the data presented?

Question28: A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

Question29: Which of the following best describes the process of examining data for statistics and information about the data?
Cleansing

Question30: The number of phone calls that the call center receives in a day is an example of:

Question31: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question32: An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit. but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

Question33: A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as-needed basis. Which of the following would be the most appropriate frequency for this report?

Question34: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question35: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question36: An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Question37: An analyst is currently working on a ticket for revamping a company-wide dashboard that has been in use for five years. Which of the following should be the first step in the development process?

Question38: Analytics reports should follow corporate style guidelines.

Question39: Given the diagram below:

Which of the following types of sampling is depicted in the image?

Question40: A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

Question41: After completing web scraping, which of the following file formats needs to be parsed?

Question42: Which of the following would be considered non-personally identifiable information?

Question43: A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

Question44: An analyst must obtain the average daily sales for the following week:

Which of the following must the analyst perform to obtain this value?

Question45: Which of the following would a data analyst look for first if 100% participation is needed on survey results?

Question46: What R package makes it easy to work with dates?

Question47: The ACME Corporation hired an analyst to detect data quality issues in their Excel documents. Which of the following are the most common issues? (Select TWO)

Question48: What SQL command is used to delete an entire table from a database?

Question49: A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?

Question50: While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Question51: Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses:

Using this information, which of the following students had the BEST score?

Question52: A data analyst has been asked to create a daily manufacturing report for the floor manager Which of the following metrics should be included in the report?

Question53: A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report Which of the following access requirements would support the director's needs?

Question54: A development company is constructing a new Init in its apartment complex. The complex has the following floor plans:

Using the average cost per square foot of the original floor plans. which of the following should be the price of the Rose Init?

Question55: Jhon is working on an ELT process that sources data from six different source systems.
Looking at the source data, he finds that data about the sample people exists in two of six systems.
What does he have to make sure he checks for in his ELT process?
Choose the best answer.

Question56: Which of the following variable name formats would be problematic if used in the majority of data software programs?

Question57: A customer list from a financial services company is shown below:

A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three numerical variables: number of credit cards, age, and income. Which of the following should the analyst do to the variables to ensure they all have the same weight in the score calculation?

Question58: A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown. Which of the following fields should be masked?

Question59: Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

Question60: A data analyst needs to create a dashboard using the company's yearly revenue data sets. Which of the following would be the best way to plot the information to show the top-performing region?

Question61: A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.
Which of the following data manipulation techniques would he use to obtain this information?

Question62: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to BEST display the data?

Question63: Given the following data:

Which of the following BEST describes the data set?

Question64: Which one of the following in NOT a common data integration tool?

Question65: Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Question66: Which of the following value is the measure of dispersion "range" between the scores of ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

Question67: An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

Question68: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to best display the data?

Question69: Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.
Which of the following systems is the most appropriate?
Choose the best answer.

Question70: A data analyst has a set with more than 40.000 rows in the sample schema below:

The analyst would like to create one column that contains the customers' birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

Question71: A sales analyst needs to report how the sales team is performing to target. Which of the following files will be important in determining 2019 performance attainment?

Question72: You have two databases tables that you would like to join together using a foreign key relationship.
What term best describes this action?

Question73: A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

Question74: Which of the following is a characteristic of a relational database?

Question75: What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?

Question76: A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

Question77: Which of the following is the correct data type for text?

Question78: Which one the following is not considered an aggregate function?

Question79: A data analyst needs to perform a full outer join of a customer's orders using the tables below:

Which of the following is the mean of the order quantity?

Question80: Encryption is a mechanism for protecting data.
When should encryption be applied to data?
Choose the best answer.

Question81: Given the following:

Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

Question82: A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

Question83: Which of the following differentiates a flat text file from other data types?

Question84: Given the below:

Which of the following numbers represents a Type I error?

Question85: Which of the following is an example of a discrete variable?

Question86: A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table -
In-store Transactions -

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

Question87: A data set was recorded using multimedia technology. Which of the following is a necessary step on the way to interpretation?

Question88: A data analyst is working with a team to create a dashboard for a client who requires on-demand access.
Which of the following is the best delivery method to support the clients' requirement?